Analysis of COVID-19 Cases in UK (England)ΒΆ

IntroductionΒΆ

This report analyzes COVID-19 case data in England to identify patterns over time.
We use the UKHSA dataset, in this analysis, we will be focusing on the date and metric_value columns. The metric value is the rate of cases per 100,000 (7-day rolling average).

Data DescriptionΒΆ

The dataset includes the following columns:

  • date β†’ the date of test specimen collection
  • geography β†’ reporting region (England)
  • metric_value β†’ Case rates by specimen date (7-day rolling average)

We'll focus on date and metric_value to create a time-series chart.

theme sub_theme topic geography_type geography metric sex age stratum year date metric_value in_reporting_delay_period
0 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-10 2.23 False
1 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-09 2.59 False
2 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-08 2.80 False
3 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-07 2.82 False
4 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-06 2.78 False
... ... ... ... ... ... ... ... ... ... ... ... ... ...
370 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-05 2.99 False
371 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-04 2.97 False
372 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-03 3.03 False
373 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-02 2.99 False
374 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-01 2.91 False

375 rows Γ— 13 columns

Data CleaningΒΆ

The data has been sorted to ensure correct chronological order. In order to plot an interactive graph, the data was sorted in way that we have a x,y plot.

X values are the Dates while the Y values are the Case Rate

theme sub_theme topic geography_type geography metric sex age stratum year date metric_value in_reporting_delay_period
374 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-01 2.91 False
373 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-02 2.99 False
372 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-03 3.03 False
371 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-04 2.97 False
370 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2024 2024-09-05 2.99 False
... ... ... ... ... ... ... ... ... ... ... ... ... ...
4 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-06 2.78 False
3 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-07 2.82 False
2 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-08 2.80 False
1 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-09 2.59 False
0 infectious_disease respiratory COVID-19 Nation England COVID-19_cases_rateRollingMean all all default 2025 2025-09-10 2.23 False

375 rows Γ— 13 columns

374    2024-09-01
373    2024-09-02
372    2024-09-03
371    2024-09-04
370    2024-09-05
          ...    
4      2025-09-06
3      2025-09-07
2      2025-09-08
1      2025-09-09
0      2025-09-10
Name: date, Length: 375, dtype: object
374    2.91
373    2.99
372    3.03
371    2.97
370    2.99
       ... 
4      2.78
3      2.82
2      2.80
1      2.59
0      2.23
Name: metric_value, Length: 375, dtype: float64

VisualizationΒΆ

The chart shows the overall trend of COVID-19 case rates over time. Hover over the chart to see exact values for any date.

Findings & InsightsΒΆ

From the chart, we can see that:

  • The highest number of cases occurred in October 2024.
  • There was a sharp decline after this peak.
  • Case rates have been relatively stable since 2025.

This suggests that interventions such as vaccines may have contributed to a lower case rate over time.